A Make2D-DB II DATABASE: version 2.50, built 18-Jul-2006

Dumped on 2006-07-18

The Make2D-DB II Tool

Index of database structure for schema: public

public

analyte
analytepreparation
analyzable
author
authorgroup
authorparent
biologicalprocess
biosource
biosourceinformation
biosourcepreparation
book
cellularcomponent
citer
commententry2d
commententryfreetext
commententryparent
commenttopic
contact
dynamicremotemake2ddbinterface
entry
entrygelimage
entrygelmaster
entrygene
entrytheoreticalpimw
entryversion2d
entryversiongeneral
entryversionparent
entryxrefdb
entryxrefdbdynamic
entryxrefdbparent
enzymenomenclature
externalmainxrefdata
gel
gelcomputabledynamic
geldynamic
gelimage
gelinformatics
gelpreparation
geltissuesp
genename
geneontologyparent
geneorderedlocus
geneorf
generaltopicdefinition
generaltopicentrydata
genesynonym
journal
make2ddbtool
mappingtopicdefinition
molecularfunction
organism
project
reference
referencedentry
referencedgel
referencedobjectparent
referencedproject
referencedsample
referencelocationbook
referencelocationjournal
referencelocationother
referencelocationparent
referencelocationpatent
referencelocationsubmission
referencelocationthesis
referencelocationunpubobservations
referencetype
referencework
release
sample
samplepreparation
secondaryac
spot
spotdataaacid
spotdataother
spotdataparent
spotdatapeptmassf
spotdatatandemms
spotentry
spotentrygeneraltopic
spotentrymappingtopic
spotentrytopicparent
spotidentificationaacid
spotidentificationother
spotidentificationparent
spotidentificationpeptmassf
spotidentificationtandemms
spotidentificationtandemmssubset
study
studygroup
tissue
tissuesp
tissuespaliase
tissuesptissuemapping
tmp_last_entry
viewentry
viewmapentrylist
viewref
viewspotentry
viewspotentrylast
xrefdb
xrefdbdynamic
xrefdbparent

Table: analyte

analyte Structure
F-Key	Name	Type	Description
	analyteid	integer
	sampleid	integer
	analytepreparationid	integer
	description	text
	analyteparentid	integer
	fromanalyzablesource	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to analyte
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: analytepreparation

analytepreparation Structure
F-Key	Name	Type	Description
	analytepreparationid	integer
	preparationprotocol	text
	uri	character varying(4096)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to analytepreparation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: analyzable

analyzable Structure
F-Key	Name	Type	Description
	analyzableid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to analyzable
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: author

author Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to author
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: authorgroup

authorgroup Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to authorgroup
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: authorparent

authorparent Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to authorparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biologicalprocess

biologicalprocess Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	goid	character varying(32)
	goname	character varying(256)
	gosynoymsnames	character varying(1024)
	godefinition	character varying(1024)
	lastupdate	timestamp without time zone
	mappedenzymeclassification	character varying(16)
	mappedtransportclassification	character varying(16)
	goparents	character varying(32)[]
	gochildren	character varying(32)[]
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biologicalprocess
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biosource

biosource Structure
F-Key	Name	Type	Description
	biosourceid	integer
	studygroupid	integer
	biosourceinformationid	integer
	biosourcepreparationid	integer
	description	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biosource
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biosourceinformation

biosourceinformation Structure
F-Key	Name	Type	Description
	biosourceinformationid	integer
	organismid	integer
	organismstrain	character varying(256)
	straindetailsdescription	text
	individualscount	character varying(256)
	genotype	character varying(16)
	developmentalstage	character varying(256)
	anatomy	character varying(256)
	tissueid	integer
	cell	character varying(256)
	cellline	character varying(256)
	measuredproperties	text
	environmet	character varying(256)
	treatment	text
	phenotype	text
	behaviour	text
	pathology	text
	provider	character varying(256)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biosourceinformation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: biosourcepreparation

biosourcepreparation Structure
F-Key	Name	Type	Description
	biosourcepreparationid	integer
	preparationprotocol	text
	uri	character varying(4096)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to biosourcepreparation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: book

book Structure
F-Key	Name	Type	Description
	bookid	integer
	booktitle	character varying(256)
	editors	character varying(256)
	publisher	character varying(128)
	city	character varying(64)
	year	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to book
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: cellularcomponent

cellularcomponent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	goid	character varying(32)
	goname	character varying(256)
	gosynoymsnames	character varying(1024)
	godefinition	character varying(1024)
	lastupdate	timestamp without time zone
	mappedenzymeclassification	character varying(16)
	mappedtransportclassification	character varying(16)
	goparents	character varying(32)[]
	gochildren	character varying(32)[]
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to cellularcomponent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: citer

citer Structure
F-Key	Name	Type	Description
	author	character varying(1024)
	article	integer
	authorpriority	smallint
	unpublished	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to citer
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commententry2d

commententry2d Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	commenttopicid	integer
	commentfreetext	text
	geldimension	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commententry2d
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commententryfreetext

commententryfreetext Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	commenttopicid	integer
	commentfreetext	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commententryfreetext
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commententryparent

commententryparent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	commenttopicid	integer
	commentfreetext	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commententryparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: commenttopic

commenttopic Structure
F-Key	Name	Type	Description
	commenttopicid	integer
	commenttopicname	character varying(64)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to commenttopic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: contact

contact Structure
F-Key	Name	Type	Description
	contactid	integer
	name	character varying(256)
	email	character varying(256)
	institution	character varying(256)
	address	text
	remark	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to contact
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: dynamicremotemake2ddbinterface

dynamicremotemake2ddbinterface Structure
F-Key	Name	Type	Description
	interfaceid	integer
	interfaceuri	text
	dbnumber	integer
	dbname	character varying(128)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to dynamicremotemake2ddbinterface
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entry

entry Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	id	character varying(32)
	entryclass	character varying(32)
	identmethod	character varying(16)
	description	text
	releasecreation	integer
	subreleasecreation	integer
	genenames	character varying(1024)
	keywords	character varying(1024)
	organismid	integer
	organismstrain	character varying(256)
	entrychecksum	character(16)
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entry
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrygelimage

entrygelimage Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	gelid	integer
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrygelimage
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrygelmaster

entrygelmaster Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	gelid	integer
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrygelmaster
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrygene

entrygene Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	geneid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrygene
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entrytheoreticalpimw

entrytheoreticalpimw Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	modifiedproteindescription	text
	theoreticalpi	numeric(4,2)
	theoreticalmw	integer
	algorithmoriginandversion	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entrytheoreticalpimw
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryversion2d

entryversion2d Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	version	integer
	versiondate	date
	annotationchanged	boolean
	annotationchecksum	character(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryversion2d
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryversiongeneral

entryversiongeneral Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	version	integer
	versiondate	date
	annotationchanged	boolean
	annotationchecksum	character(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryversiongeneral
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryversionparent

entryversionparent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	version	integer
	versiondate	date
	annotationchanged	boolean
	annotationchecksum	character(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryversionparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryxrefdb

entryxrefdb Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	xrefdbcode	integer
	xrefprimaryidentifier	character varying(32)
	xrefsecondaryidentifier	character varying(1024)
	xreftertiaryidentifier	character varying(1024)
	xrefotheridentifiers	character varying(1024)
	activated	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryxrefdb
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryxrefdbdynamic

entryxrefdbdynamic Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	xrefdbcode	integer
	xrefprimaryidentifier	character varying(32)
	xrefsecondaryidentifier	character varying(1024)
	xreftertiaryidentifier	character varying(1024)
	xrefotheridentifiers	character varying(1024)
	activated	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryxrefdbdynamic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: entryxrefdbparent

entryxrefdbparent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	xrefdbcode	integer
	xrefprimaryidentifier	character varying(32)
	xrefsecondaryidentifier	character varying(1024)
	xreftertiaryidentifier	character varying(1024)
	xrefotheridentifiers	character varying(1024)
	activated	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to entryxrefdbparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: enzymenomenclature

enzymenomenclature Structure
F-Key	Name	Type	Description
	enzymecode	character varying(16)
	ac	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to enzymenomenclature
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: externalmainxrefdata

externalmainxrefdata Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	uniprotextractiondate	date
	uniprotac	character varying(32)
	uniprotsecondaryac	character varying(32)[]
	uniprotid	character varying(32)
	uniprotversion	numeric(5,2)
	uniprotentryincorporateddate	date
	uniprotsequpdate	date
	uniprotsequpversion	smallint
	uniprotentryupdate	date
	uniprotentryupversion	smallint
	uniprotdescription	text
	uniprotenzymecode	character varying(16)
	uniprotgenenames	character varying(1024)
	uniprotorganelleplasmid	character varying(256)
	uniprotcategorykeywords	character varying(1024)
	uniprotxrefs	character varying(1024)[]
	sportrembl	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to externalmainxrefdata
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: gel

gel Structure
F-Key	Name	Type	Description
	gelid	integer
	melaniegeneratedid	character varying(64)
	shortname	character varying(32)
	fullname	character varying(256)
	dimension	smallint
	startmw	bigint
	endmw	bigint
	startpi	numeric(4,2)
	endpi	numeric(4,2)
	organismid	integer
	organismstrain	character varying(256)
	gelparentid	integer
	gelpreparationid	integer
	gelinformaticsid	integer
	biosourceinformationid	integer
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to gel
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: gelcomputabledynamic

gelcomputabledynamic Structure
F-Key	Name	Type	Description
	databasename	character varying(64)
	gelshortname	character varying(32)
	gelfullname	character varying(256)
	organismspecies	text
	taxonomycode	integer
	gelcomputableurl	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to gelcomputabledynamic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: geldynamic

geldynamic Structure
F-Key	Name	Type	Description
	databasename	character varying(64)
	gelshortname	character varying(32)
	gelfullname	character varying(256)
	organismspecies	text
	taxonomycode	integer
	tissuename	character varying(256)
	tissuespname	character varying(256)
	gelurl	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to geldynamic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: gelimage

gelimage Structure
F-Key	Name	Type	Description
	gelid	integer
	masterimage	oid
	imageurl	text
	imagepath	text
	imagetype	character varying(3)
	smallimageurl	text
	smallimagepath	text
	smallimagetype	character varying(3)
	xpixelsize	smallint
	ypixelsize	smallint
	xratio	numeric(6,4)
	yratio	numeric(6,4)
	xpixelshift	smallint
	ypixelshift	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to gelimage
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: gelinformatics

gelinformatics Structure
F-Key	Name	Type	Description
	gelinformaticsid	integer
	uri	character varying(4096)
	informaticsdocument	text
	informaticsdescription	text
	soft	text
	contactid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to gelinformatics
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: gelpreparation

gelpreparation Structure
F-Key	Name	Type	Description
	gelpreparationid	integer
	analyteid	integer
	uri	character varying(4096)
	preparationdocument	text
	preparationdescription	text
	contactid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to gelpreparation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: geltissuesp

geltissuesp Structure
F-Key	Name	Type	Description
	gelid	integer
	tissuespname	character varying(256)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to geltissuesp
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: genename

genename Structure
F-Key	Name	Type	Description
	geneid	integer
	genename	character varying(16)
	organismid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to genename
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: geneontologyparent

geneontologyparent Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	goid	character varying(32)
	goname	character varying(256)
	gosynoymsnames	character varying(1024)
	godefinition	character varying(1024)
	lastupdate	timestamp without time zone
	mappedenzymeclassification	character varying(16)
	mappedtransportclassification	character varying(16)
	goparents	character varying(32)[]
	gochildren	character varying(32)[]
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to geneontologyparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: geneorderedlocus

geneorderedlocus Structure
F-Key	Name	Type	Description
	geneid	integer
	orderedlocusname	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to geneorderedlocus
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: geneorf

geneorf Structure
F-Key	Name	Type	Description
	geneid	integer
	orfname	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to geneorf
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: generaltopicdefinition

generaltopicdefinition Structure
F-Key	Name	Type	Description
	generaltopicid	integer
	topicname	character varying(64)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to generaltopicdefinition
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: generaltopicentrydata

generaltopicentrydata Structure
F-Key	Name	Type	Description
	topicdataid	integer
	generaltopicid	integer
	topicdatatext	text
	allreferences	integer[]
	ambiguousreference	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to generaltopicentrydata
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: genesynonym

genesynonym Structure
F-Key	Name	Type	Description
	geneid	integer
	synonym	character varying(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to genesynonym
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: journal

journal Structure
F-Key	Name	Type	Description
	journalid	integer
	journalname	character varying(256)
	url	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to journal
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: make2ddbtool

make2ddbtool Structure
F-Key	Name	Type	Description
	version	numeric(4,2)
	subversion	character varying(64)
	versiondate	date
	postgresqlversion	text
	action	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to make2ddbtool
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: mappingtopicdefinition

mappingtopicdefinition Structure
F-Key	Name	Type	Description
	mappingtechnique	character varying(8)
	techniquedescription	character varying(256)
	containingregexp	text
	excludingregexp	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to mappingtopicdefinition
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: molecularfunction

molecularfunction Structure
F-Key	Name	Type	Description
	ac	character varying(32)
	goid	character varying(32)
	goname	character varying(256)
	gosynoymsnames	character varying(1024)
	godefinition	character varying(1024)
	lastupdate	timestamp without time zone
	mappedenzymeclassification	character varying(16)
	mappedtransportclassification	character varying(16)
	goparents	character varying(32)[]
	gochildren	character varying(32)[]
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to molecularfunction
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: organism

organism Structure
F-Key	Name	Type	Description
	organismid	integer
	organismspecies	text
	organismclassification	text
	taxonomyxrefdbcode	integer
	taxonomycode	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to organism
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: project

project Structure
F-Key	Name	Type	Description
	projectid	integer
	description	text
	uri	character varying(4096)
	contactid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to project
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: reference

reference Structure
F-Key	Name	Type	Description
	referenceid	integer
	referenceworkid	integer
	referencetitle	text
	referencetypeid	integer
	referencechecksum	character(16)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to reference
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencedentry

referencedentry Structure
F-Key	Name	Type	Description
	referenceid	integer
	ac	character varying(32)
	rndisplayedvalue	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencedentry
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencedgel

referencedgel Structure
F-Key	Name	Type	Description
	referenceid	integer
	gelid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencedgel
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencedobjectparent

referencedobjectparent Structure
F-Key	Name	Type	Description
	referenceid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencedobjectparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencedproject

referencedproject Structure
F-Key	Name	Type	Description
	referenceid	integer
	projectid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencedproject
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencedsample

referencedsample Structure
F-Key	Name	Type	Description
	referenceid	integer
	sampleid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencedsample
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationbook

referencelocationbook Structure
F-Key	Name	Type	Description
	referenceid	integer
	bookid	integer
	volume	smallint
	pagefirst	integer
	pagelast	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationbook
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationjournal

referencelocationjournal Structure
F-Key	Name	Type	Description
	referenceid	integer
	journalid	integer
	volume	smallint
	subvolume	smallint
	pagefirst	integer
	pagelast	integer
	year	smallint
	crossreferences	character varying(128)[]
	unpublished	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationjournal
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationother

referencelocationother Structure
F-Key	Name	Type	Description
	referenceid	integer
	text	text
	personalcomment	character varying(256)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationother
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationparent

referencelocationparent Structure
F-Key	Name	Type	Description
	referenceid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationpatent

referencelocationpatent Structure
F-Key	Name	Type	Description
	referenceid	integer
	patent_publication_number	character varying(16)
	date	date
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationpatent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationsubmission

referencelocationsubmission Structure
F-Key	Name	Type	Description
	referenceid	integer
	month	smallint
	year	smallint
	xrefdbcode	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationsubmission
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationthesis

referencelocationthesis Structure
F-Key	Name	Type	Description
	referenceid	integer
	year	smallint
	institution	character varying(128)
	country	character varying(64)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationthesis
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencelocationunpubobservations

referencelocationunpubobservations Structure
F-Key	Name	Type	Description
	referenceid	integer
	month	smallint
	year	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencelocationunpubobservations
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencetype

referencetype Structure
F-Key	Name	Type	Description
	referencetypeid	integer
	referencetype	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencetype
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: referencework

referencework Structure
F-Key	Name	Type	Description
	referenceworkid	integer
	referenceworkdescription	character varying(64)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to referencework
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: release

release Structure
F-Key	Name	Type	Description
	releasenum	integer
	subrelease	smallint
	releasedate	date
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to release
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: sample

sample Structure
F-Key	Name	Type	Description
	sampleid	integer
	biosourceid	integer
	uri	character varying(4096)
	samplepreparationid	integer
	description	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to sample
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: samplepreparation

samplepreparation Structure
F-Key	Name	Type	Description
	samplepreparationid	integer
	uri	character varying(4096)
	samplepreparationdocument	text
	samplepreparationprotocol	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to samplepreparation
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: secondaryac

secondaryac Structure
F-Key	Name	Type	Description
	secondaryac	character varying(32)
	ac	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to secondaryac
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spot

spot Structure
F-Key	Name	Type	Description
	spotid	character varying(16)
	gelid	integer
	mw	integer
	pi	numeric(4,2)
	xcoordinate	integer
	ycoordinate	integer
	odrelative	real
	volumerelative	real
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spot
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotdataaacid

spotdataaacid Structure
F-Key	Name	Type	Description
	dataexpid	integer
	humanidentifier	character varying(256)
	spotid	character varying(16)
	gelid	integer
	referenceid	integer
	contactid	integer
	uri	character varying(4096)
	datadocument	text
	experimentdescription	text
	experimentdate	date
	appreciation	smallint
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	aminoacidlist	text
	relateddata	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotdataaacid
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotdataother

spotdataother Structure
F-Key	Name	Type	Description
	dataexpid	integer
	humanidentifier	character varying(256)
	spotid	character varying(16)
	gelid	integer
	referenceid	integer
	contactid	integer
	uri	character varying(4096)
	datadocument	text
	experimentdescription	text
	experimentdate	date
	appreciation	smallint
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	results	text
	relateddata	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotdataother
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotdataparent

spotdataparent Structure
F-Key	Name	Type	Description
	dataexpid	integer
	humanidentifier	character varying(256)
	spotid	character varying(16)
	gelid	integer
	referenceid	integer
	contactid	integer
	uri	character varying(4096)
	datadocument	text
	experimentdescription	text
	experimentdate	date
	appreciation	smallint
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotdataparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotdatapeptmassf

spotdatapeptmassf Structure
F-Key	Name	Type	Description
	dataexpid	integer
	humanidentifier	character varying(256)
	spotid	character varying(16)
	gelid	integer
	referenceid	integer
	contactid	integer
	uri	character varying(4096)
	datadocument	text
	experimentdescription	text
	experimentdate	date
	appreciation	smallint
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	peptidemasses	double precision[]
	enzyme	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotdatapeptmassf
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotdatatandemms

spotdatatandemms Structure
F-Key	Name	Type	Description
	dataexpid	integer
	humanidentifier	character varying(256)
	spotid	character varying(16)
	gelid	integer
	referenceid	integer
	contactid	integer
	uri	character varying(4096)
	datadocument	text
	experimentdescription	text
	experimentdate	date
	appreciation	smallint
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	parentmass	double precision
	parentcharge	smallint
	ionmasses	double precision[]
	relateddata	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotdatatandemms
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotentry

spotentry Structure
F-Key	Name	Type	Description
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	fragment	boolean
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotentry
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotentrygeneraltopic

spotentrygeneraltopic Structure
F-Key	Name	Type	Description
	topicdataid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotentrygeneraltopic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotentrymappingtopic

spotentrymappingtopic Structure
F-Key	Name	Type	Description
	topicdataid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	mappingtechnique	character varying(8)[]
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotentrymappingtopic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotentrytopicparent

spotentrytopicparent Structure
F-Key	Name	Type	Description
	topicdataid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotentrytopicparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotidentificationaacid

spotidentificationaacid Structure
F-Key	Name	Type	Description
	identificationid	integer
	humanidentifier	character varying(256)
	hassubset	boolean
	dataexpid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	isoform	text
	version	integer
	contactid	integer
	uri	character varying(4096)
	identificationdocument	text
	identificationdescription	text
	allexperimentdata	boolean
	appreciation	numeric(2,1)
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	aminoacidlist	text
	relateddata	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotidentificationaacid
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotidentificationother

spotidentificationother Structure
F-Key	Name	Type	Description
	identificationid	integer
	humanidentifier	character varying(256)
	hassubset	boolean
	dataexpid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	isoform	text
	version	integer
	contactid	integer
	uri	character varying(4096)
	identificationdocument	text
	identificationdescription	text
	allexperimentdata	boolean
	appreciation	numeric(2,1)
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	results	text
	relateddata	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotidentificationother
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotidentificationparent

spotidentificationparent Structure
F-Key	Name	Type	Description
	identificationid	integer
	humanidentifier	character varying(256)
	hassubset	boolean
	dataexpid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	isoform	text
	version	integer
	contactid	integer
	uri	character varying(4096)
	identificationdocument	text
	identificationdescription	text
	allexperimentdata	boolean
	appreciation	numeric(2,1)
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotidentificationparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotidentificationpeptmassf

spotidentificationpeptmassf Structure
F-Key	Name	Type	Description
	identificationid	integer
	humanidentifier	character varying(256)
	hassubset	boolean
	dataexpid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	isoform	text
	version	integer
	contactid	integer
	uri	character varying(4096)
	identificationdocument	text
	identificationdescription	text
	allexperimentdata	boolean
	appreciation	numeric(2,1)
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	peptidemasses	double precision[]
	relateddata	text
	xxac	character varying(32)
	xxdirectory	character varying(256)
	xxfile	character varying(64)
	xxprogversion	character varying(64)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotidentificationpeptmassf
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotidentificationtandemms

spotidentificationtandemms Structure
F-Key	Name	Type	Description
	identificationid	integer
	humanidentifier	character varying(256)
	hassubset	boolean
	dataexpid	integer
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	isoform	text
	version	integer
	contactid	integer
	uri	character varying(4096)
	identificationdocument	text
	identificationdescription	text
	allexperimentdata	boolean
	appreciation	numeric(2,1)
	datadisplayer	text
	showflag	boolean
	showflagswitch	boolean
	ionmasses	double precision[]
	relateddata	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotidentificationtandemms
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: spotidentificationtandemmssubset

spotidentificationtandemmssubset Structure
F-Key	Name	Type	Description
	identificationid	integer
	ionmasses	double precision[]
	identifiedpeptidesequence	text
	sequencestartposition	smallint
	sequenceendposition	smallint
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to spotidentificationtandemmssubset
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: study

study Structure
F-Key	Name	Type	Description
	studyid	integer
	projectid	integer
	description	text
	contactid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to study
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: studygroup

studygroup Structure
F-Key	Name	Type	Description
	studygroupid	integer
	studyid	integer
	description	text
	biosourceinformationid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to studygroup
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: tissue

tissue Structure
F-Key	Name	Type	Description
	tissueid	integer
	tissuename	character varying(256)
	tissueparentid	integer
	tissuecomment	character varying(1024)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to tissue
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: tissuesp

tissuesp Structure
F-Key	Name	Type	Description
	tissuespname	character varying(256)
	tissuespdisplayedname	character varying(256)
	tissueindate	date
	tissuecomment	character varying(1024)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to tissuesp
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: tissuespaliase

tissuespaliase Structure
F-Key	Name	Type	Description
	tissuespname	character varying(256)
	alias	character varying(256)
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to tissuespaliase
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: tissuesptissuemapping

tissuesptissuemapping Structure
F-Key	Name	Type	Description
	tissuespname	character varying(256)
	tissueid	integer
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to tissuesptissuemapping
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: tmp_last_entry

tmp_last_entry Structure
F-Key	Name	Type	Description
	identifier	character varying(32)
	id_method	character varying(48)
	accession_number	character varying(32)
	secondary_identifiers	text
	creation	text
	version_2d	text
	version_general	text
	description	text
	genes	text
	organism	text
	organism_classification	text
	taxonomy_cross_reference	text
	masters	text
	images	text
	free_comments	text
	reference_lines	text
	one_d_comments	text
	one_d_blocks	text
	two_d_comments	text
	two_d_blocks	text
	database_cross_reference	text

Permissions which apply to tmp_last_entry
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: viewentry

viewentry Structure
F-Key	Name	Type	Description
	identifier	character varying(32)
	id_method	character varying(48)
	accession_number	character varying(32)
	secondary_identifiers	text
	creation	text
	version_2d	text
	version_general	text
	description	text
	genes	text
	organism	text
	organism_classification	text
	taxonomy_cross_reference	text
	masters	text
	images	text
	free_comments	text
	reference_lines	text
	one_d_comments	text
	one_d_blocks	text
	two_d_comments	text
	two_d_blocks	text
	database_cross_reference	text

Permissions which apply to viewentry
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: viewmapentrylist

viewmapentrylist Structure
F-Key	Name	Type	Description
	gelid	integer
	genes	character varying(1024)
	description	text
	spotid	character varying(16)
	ac	character varying(32)
	id	character varying(32)
	pi	numeric(4,2)
	mw	numeric(6,3)
	volumerelative	real
	odrelative	real
	fragment	boolean
	topicdescription	text
	mappingtechniques	text
	availableresults	text
	rn_references	text
	referenceids	text
	showflag	boolean
	showflagswitch	boolean

Permissions which apply to viewmapentrylist
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: viewref

viewref Structure
F-Key	Name	Type	Description
	referenceid	integer
	referenceworkdescription	character varying(64)
	crossreferences	character varying(256)
	authorsgroup	character varying(2048)
	authors	character varying(8192)
	referencetitle	text
	referencelocation	text

Permissions which apply to viewref
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: viewspotentry

viewspotentry Structure
F-Key	Name	Type	Description
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	fragment	boolean
	aminoacidlist	text
	aa_version	integer
	msms	text
	ms_version	integer
	peptidesequences	text
	peptseq_version	integer
	peptidemasses	text
	pmf_version	integer
	showflag	boolean
	showflagswitch	boolean

Permissions which apply to viewspotentry
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: viewspotentrylast

viewspotentrylast Structure
F-Key	Name	Type	Description
	spotid	character varying(16)
	gelid	integer
	ac	character varying(32)
	fragment	boolean
	aminoacidlist	text
	aa_version	integer
	msms	text
	ms_version	integer
	peptidesequences	text
	peptseq_version	integer
	peptidemasses	text
	pmf_version	integer
	showflag	boolean
	showflagswitch	boolean

Permissions which apply to viewspotentrylast
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: xrefdb

xrefdb Structure
F-Key	Name	Type	Description
	xrefdbcode	integer
	xrefdbname	character varying(64)
	description	text
	url	text
	displayerurl	text
	displayerparameters	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to xrefdb
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: xrefdbdynamic

xrefdbdynamic Structure
F-Key	Name	Type	Description
	xrefdbcode	integer
	xrefdbname	character varying(64)
	description	text
	url	text
	displayerurl	text
	displayerparameters	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to xrefdbdynamic
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Table: xrefdbparent

xrefdbparent Structure
F-Key	Name	Type	Description
	xrefdbcode	integer
	xrefdbname	character varying(64)
	description	text
	url	text
	displayerurl	text
	displayerparameters	text
	userstamp	character varying(128)
	update	timestamp without time zone

Permissions which apply to xrefdbparent
User	Select	Insert	Update	Delete	Reference	Rule	Trigger
mostaguir	♦	♦	♦	♦	♦	♦	♦
select2d	♦

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict